Views [dbo].[vRecycle_Bin]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created3:38:38 PM Friday, January 07, 2011
Last Modified1:49:22 PM Thursday, September 22, 2011
Columns
Name
Description
Keywords
ShowInTemplateFlag
PublishDateTime
PublishSetManuallyFlag
PublishLocation
ImportantUntilDate
ExpirationDate
ExpirationDays
ExpSetManuallyFlag
ArchiveAtExpirationFlag
ReminderSentDateTime
AutoCreatedFlag
ListDefaultPublishLocation
PublicationDate
SubscriptionDate
PublishFrequency
SuppressBannersFlag
ContentID
WorkflowStatusCode
OriginalContentID
PreviousContentID
NavMenuID
Name
URLSafeName
OpenInNewWindowFlag
FuseFlag
SecureFlag
OwnerContactID
ContactID
OwnerSetManuallyFlag
SortOrder
MembersOnlyFlag
UserDefinedDate1
UserDefinedDate2
UserDefinedString1
UserDefinedString2
UserDefinedNumeric1
UserDefinedNumeric2
ComponentCode
PreFuseURL
PostFuseURL
UserDefinedDate3
UserDefinedDate4
UserDefinedDate5
UserDefinedString3
UserDefinedString4
UserDefinedString5
UserDefinedNumeric3
UserDefinedNumeric4
UserDefinedNumeric5
SQL Script
/*==============================================================*/
/* View: vRecycle_Bin                           */
/*==============================================================*/
CREATE      VIEW vRecycle_Bin AS
SELECT a.*
FROM Content a
LEFT OUTER JOIN Content b
ON a.ContentID = b.PreviousContentID
WHERE a.WorkflowStatusCode IN ('Y','D')
AND b.ContentID IS NULL

GO
Uses
Used By